Creating line and stacked column chart and map 16

Line and stacked column chart

a.       Creating line and stacked column chart and map

On field and shared axis Language column, and  column value WORDS PER DAY and Line value MOM %

b.       To Format, Go to General X position = 0, y position =77, width = 533, height = 373

c.        Legend = ON color black (000000) font family =Cambria Math, text 12 style =markers only, Match line color =on, circle default icon =on

d.       x-axis color black, text size 15, font family = Cambria Math, minimum category width 20 Max = 20 Inner padding 20% concatenate labels on, Title off 

e.       y-axis color(605E5C) text size 15,  font family Cambria Math and title =off

f.          Gridlines on color (B3B3B3) stoke width 1, line style =solid , show secondary= on Align zeros= On

g.       Y-Axis(Line), color (FF9C80) text Size 16 font family Cambria Math, Title= off

h.       data Colors ,MOM% = (FF9C80), Default color( 99CDE7)

i.         Data labels On, color(8952BF )text size 21, font family Cambria Math, ,show background on , background color  =white  transparency  30%

j.         customize series on , WORDS PER DAY color (074650) text size =21,

font family Cambria Math, show background =on, background color = white

k.        shapes area On, stroke width 0, join types Miter Line style solid

l.         Tittle on ‘MAX LANGUAGE COMPLETENESS AVG PER DAY’ , word wrap on font color black, background color(6DB6FF),alignment = center , text size = 17  font family =Cambria Math

m.     Background = off

n.       Lock aspect =off

o.       Border = off

p.       Tooltip = on

q.       Visual header= on

Follow gif. 


once you are done with above detail instruction with text size and changing title  so on so forth copy and past the chart 3 more time and follow gif as well as write instructions 


Line and stacked column chart

On field and shared axis Monthlong  column, and  column value WORDS PER DAY and Line value MOM %

To Format, Go to General X position = 713, y position =72, width = 567, height = 288

Change the Title to

Title = YEARLY COMPLETENESS  PER AVG

follow Gif 



Map


 

On field and Location = table sheet1 Language, Latitude = Average of Latitude, Longitude = Average of longitude   and Size = Count per Day

To Format, Go to General X position = 0, y position =374, width = 497, height = 338

Data colors click one (fx) and Minimum = red (FF0711), and for maximum =(118DFF ), category labels =On ,    color = (666666) Text size= 17, Font family = Cambria Math,  show background = off ,bubbles Size = 21,  Heat map =off ,  Title =On change the titles to (WORDS PER DAY BY LOCATION ) , show background= off  Too tips on , visual header= on   

And for map Legend please select insert image from power bi ribbon go on your download zip file choose  the image  Once you insert the image  go to power bi ribbon and select format  select  Bring forward   To format image general x position= 221 ,Y Position= 809 ,width= 297 and height= 68

More detail screenshot and gif below please follow.









https://okviz.com/blog/design-guide-for-power-bi-slicers-and-filters